use DATABASENAME
exec sp_addumpdevice 'disk','logfilename','d:logfilename.log'
declare @i tinyint
set @i=1
while @i<21
begin
set @i=@i+1
backup log DATABASENAME to logfilename
dbcc shrinkfile(1,1)
dbcc shrinkfile(2,1)
end
نظرات شما عزیزان:
برچسبها: